
CREATE TABLE `webdev_assignments` (
  `id` bigint(20) NOT NULL auto_increment,
  `title` varchar(100) NOT NULL,
  `description` varchar(1024) default NULL,
  `deadline` datetime NOT NULL,
  `courseofferingId` bigint(20) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8$$


delimiter $$

CREATE TABLE `webdev_courseoffering` (
  `id` bigint(20) NOT NULL auto_increment,
  `courseNumber` varchar(50) NOT NULL,
  `quarterId` bigint(20) NOT NULL,
  `facultyId` bigint(20) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8$$


delimiter $$

CREATE TABLE `webdev_courses` (
  `number` varchar(50) NOT NULL,
  `name` varchar(250) NOT NULL,
  PRIMARY KEY  (`number`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8$$


delimiter $$

CREATE TABLE `webdev_enrollments` (
  `courseoffering_Id` bigint(20) NOT NULL,
  `studentId` bigint(20) NOT NULL,
  PRIMARY KEY  (`courseoffering_Id`,`studentId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8$$


delimiter $$

CREATE TABLE `webdev_quarters` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(45) NOT NULL,
  `year` bigint(20) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8$$


delimiter $$

CREATE TABLE `webdev_ratings` (
  `id` bigint(20) NOT NULL auto_increment,
  `postId` bigint(20) NOT NULL,
  `post_authorId` bigint(20) NOT NULL,
  `rating` tinyint(4) NOT NULL,
  `date` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8$$